First Solution Exercise 1¶

Exercise objectives:

a) Display the basins on the map using a color scale based on the average value of the series between 1/1980 and 12/2020 [Classify into 5 color ranges]

b) Briefly describe the challenges you faced in developing the exercise in terms of deployment and the solutions you found to present the exercise in a way that is fluid in the requested functionalities.

First solution: creation and development of an online application using GIS tools and ESRI products: ArcGIS Pro, ArcGIS API For python, ArcGIS Online, and ArcGIS Dashboards¶

ArcGIS API For Python¶

Import of packages and libraries¶

In [1]:
from arcgis.map.renderers import (ClassBreaksRenderer, ClassBreakInfo, SizeInfoVisualVariable)
from arcgis.map.symbols import SimpleLineSymbolEsriSLS, SimpleFillSymbolEsriSFS
import numpy as np
import pandas as pd
import math
import os
import time

from datetime import datetime as dt
from IPython.display import Image, HTML
from copy import deepcopy

from arcgis.gis import GIS
from arcgis.features import FeatureLayer, FeatureLayerCollection
from arcgis.geometry import SpatialReference

import arcpy
from arcpy.sa import*
from arcpy.ia import*
from arcpy import env
from arcgis.raster.functions import *

# connect to GIS
from arcgis.gis import GIS
from arcgis.geometry import SpatialReference

Access and Login into ArcGIS Account¶

In [2]:
# Prompt user to provide username and password
import getpass
username = input('Enter username: ')
password = getpass.getpass("Enter your password: ") 
gis = GIS("https://udistritalfjc.maps.arcgis.com/home", username, password)

Definition WorkSpace¶

In [3]:
path = os.chdir(r'C:\Users\USUARIO\Downloads\SEI\Time_series')
path = os.getcwd()
path
Out[3]:
'C:\\Users\\USUARIO\\Downloads\\SEI\\Time_series'

Import the Time Series in (.csv) format¶

In [4]:
data = pd.pandas.read_csv(r'WEAP_Escorrentia_convertido.csv', parse_dates=True)
print(data.head())
             Branch   1980_01_01   1980_02_01   1980_03_01   1980_04_01  \
0      MC_Amazonica    9908141.0   48506012.0   39480903.0    8497107.0   
1    MC_Amazonica_2  304846288.0  919079586.0  872686746.0  189000241.0   
2    MC_Amazonica_3   87731407.0  275746942.0  233070128.0   23127988.0   
3  MC_Amazonica_3_2     379626.0     435883.0     372386.0      77466.2   
4    MC_del Plata_2   85433274.0    2466356.0   46074512.0     880844.0   

   1980_05_01   1980_06_01    1980_07_01    1980_08_01  1980_09_01  ...  \
0   691351.00   8619.57000   1182.230000   1017.620000    122198.0  ...   
1  9277375.00  62110.40000  16641.600000  47252.700000    540484.0  ...   
2   799298.00  18899.80000  33878.600000  74130.000000    287545.0  ...   
3    21306.10   2869.98000  11985.800000  18051.300000     42887.5  ...   
4     2597.12      1.30297      0.000722      0.000013         0.0  ...   

     2020_03_01    2020_04_01    2020_05_01  2020_06_01  2020_07_01  \
0  1.409411e+06  3.494760e+04  2.536040e+02    0.001125    0.000000   
1  1.227830e+08  1.139652e+08  2.480621e+06   45.635800    0.000743   
2  9.371000e+05  5.602030e+02  5.266690e+01    0.336177    0.004936   
3  7.147130e+00  3.866360e+00  1.247020e-01    0.001064    0.000220   
4  6.129370e+05  4.075930e+03  3.224070e+01    0.000257    0.000000   

   2020_08_01  2020_09_01  2020_10_01  2020_11_01    2020_12_01  
0    0.000000    0.000000    0.000000    0.000000  1.357970e+05  
1    0.000005    0.000009    0.676763    0.324648  1.240486e+07  
2    0.000083    0.000016    0.077703    0.015837  1.137960e+04  
3    0.000002    0.000004    0.012802    0.000576  8.756010e+01  
4    0.000000    0.000012    0.113204  103.041000  3.873790e+04  

[5 rows x 493 columns]

Adding a new column to the CSV table¶

In [5]:
data['avg_80_20'] = None

Calculation of averages “avg” between 1980 and 2020 for the 260 river basins¶

In [6]:
row_averages = data.mean(axis=1, skipna=True, numeric_only=True)
data['avg_80_20'] = row_averages
print(data['avg_80_20'])
0      1.013722e+07
1      2.318555e+08
2      2.920528e+07
3      4.192243e+03
4      9.659120e+06
           ...     
255    1.672150e+04
256    5.087154e+07
257    1.924588e+08
258    1.105286e+06
259    1.759081e+04
Name: avg_80_20, Length: 260, dtype: float64
In [7]:
field_name = "avg_80_20"
if field_name in data.columns:
    print(f"Statistics for '{field_name}':")
    print(data[field_name].describe()) # Provides count, mean, std, min, max, quartiles
else:
    print(f"Field '{field_name}' not found in the DataFrame.")
Statistics for 'avg_80_20':
count    2.600000e+02
mean     6.073037e+07
std      1.807277e+08
min      5.055668e-01
25%      1.266384e+05
50%      3.570129e+06
75%      3.966394e+07
max      2.162925e+09
Name: avg_80_20, dtype: float64

Export the time series in WorkSpace¶

In [8]:
arcpy.conversion.ExportTable(
    in_table= data,
    out_table=r"C:\Users\USUARIO\Downloads\SEI\Time_series\WEAP_Escorrentia_completo.csv",
    where_clause="",
    use_field_alias_as_name="NOT_USE_ALIAS",
    field_mapping='Branch "Branch" true true false 8000 Text 0 0,First,#,WEAP_Escorrentia_convertido.csv,Branch,0,7999;1980-01-01_ "1980-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-01-01_,-1,-1;1980-02-01_ "1980-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-02-01_,-1,-1;1980-03-01_ "1980-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-03-01_,-1,-1;1980-04-01_ "1980-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-04-01_,-1,-1;1980-05-01_ "1980-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-05-01_,-1,-1;1980-06-01_ "1980-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-06-01_,-1,-1;1980-07-01_ "1980-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-07-01_,-1,-1;1980-08-01_ "1980-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-08-01_,-1,-1;1980-09-01_ "1980-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-09-01_,-1,-1;1980-10-01_ "1980-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-10-01_,-1,-1;1980-11-01_ "1980-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-11-01_,-1,-1;1980-12-01_ "1980-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1980-12-01_,-1,-1;1981-01-01_ "1981-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-01-01_,-1,-1;1981-02-01_ "1981-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-02-01_,-1,-1;1981-03-01_ "1981-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-03-01_,-1,-1;1981-04-01_ "1981-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-04-01_,-1,-1;1981-05-01_ "1981-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-05-01_,-1,-1;1981-06-01_ "1981-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-06-01_,-1,-1;1981-07-01_ "1981-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-07-01_,-1,-1;1981-08-01_ "1981-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-08-01_,-1,-1;1981-09-01_ "1981-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-09-01_,-1,-1;1981-10-01_ "1981-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-10-01_,-1,-1;1981-11-01_ "1981-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-11-01_,-1,-1;1981-12-01_ "1981-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1981-12-01_,-1,-1;1982-01-01_ "1982-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-01-01_,-1,-1;1982-02-01_ "1982-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-02-01_,-1,-1;1982-03-01_ "1982-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-03-01_,-1,-1;1982-04-01_ "1982-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-04-01_,-1,-1;1982-05-01_ "1982-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-05-01_,-1,-1;1982-06-01_ "1982-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-06-01_,-1,-1;1982-07-01_ "1982-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-07-01_,-1,-1;1982-08-01_ "1982-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-08-01_,-1,-1;1982-09-01_ "1982-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-09-01_,-1,-1;1982-10-01_ "1982-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-10-01_,-1,-1;1982-11-01_ "1982-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-11-01_,-1,-1;1982-12-01_ "1982-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1982-12-01_,-1,-1;1983-01-01_ "1983-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-01-01_,-1,-1;1983-02-01_ "1983-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-02-01_,-1,-1;1983-03-01_ "1983-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-03-01_,-1,-1;1983-04-01_ "1983-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-04-01_,-1,-1;1983-05-01_ "1983-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-05-01_,-1,-1;1983-06-01_ "1983-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-06-01_,-1,-1;1983-07-01_ "1983-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-07-01_,-1,-1;1983-08-01_ "1983-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-08-01_,-1,-1;1983-09-01_ "1983-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-09-01_,-1,-1;1983-10-01_ "1983-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-10-01_,-1,-1;1983-11-01_ "1983-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-11-01_,-1,-1;1983-12-01_ "1983-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1983-12-01_,-1,-1;1984-01-01_ "1984-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-01-01_,-1,-1;1984-02-01_ "1984-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-02-01_,-1,-1;1984-03-01_ "1984-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-03-01_,-1,-1;1984-04-01_ "1984-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-04-01_,-1,-1;1984-05-01_ "1984-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-05-01_,-1,-1;1984-06-01_ "1984-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-06-01_,-1,-1;1984-07-01_ "1984-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-07-01_,-1,-1;1984-08-01_ "1984-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-08-01_,-1,-1;1984-09-01_ "1984-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-09-01_,-1,-1;1984-10-01_ "1984-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-10-01_,-1,-1;1984-11-01_ "1984-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-11-01_,-1,-1;1984-12-01_ "1984-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1984-12-01_,-1,-1;1985-01-01_ "1985-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-01-01_,-1,-1;1985-02-01_ "1985-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-02-01_,-1,-1;1985-03-01_ "1985-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-03-01_,-1,-1;1985-04-01_ "1985-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-04-01_,-1,-1;1985-05-01_ "1985-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-05-01_,-1,-1;1985-06-01_ "1985-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-06-01_,-1,-1;1985-07-01_ "1985-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-07-01_,-1,-1;1985-08-01_ "1985-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-08-01_,-1,-1;1985-09-01_ "1985-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-09-01_,-1,-1;1985-10-01_ "1985-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-10-01_,-1,-1;1985-11-01_ "1985-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-11-01_,-1,-1;1985-12-01_ "1985-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1985-12-01_,-1,-1;1986-01-01_ "1986-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-01-01_,-1,-1;1986-02-01_ "1986-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-02-01_,-1,-1;1986-03-01_ "1986-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-03-01_,-1,-1;1986-04-01_ "1986-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-04-01_,-1,-1;1986-05-01_ "1986-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-05-01_,-1,-1;1986-06-01_ "1986-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-06-01_,-1,-1;1986-07-01_ "1986-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-07-01_,-1,-1;1986-08-01_ "1986-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-08-01_,-1,-1;1986-09-01_ "1986-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-09-01_,-1,-1;1986-10-01_ "1986-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-10-01_,-1,-1;1986-11-01_ "1986-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-11-01_,-1,-1;1986-12-01_ "1986-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1986-12-01_,-1,-1;1987-01-01_ "1987-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-01-01_,-1,-1;1987-02-01_ "1987-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-02-01_,-1,-1;1987-03-01_ "1987-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-03-01_,-1,-1;1987-04-01_ "1987-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-04-01_,-1,-1;1987-05-01_ "1987-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-05-01_,-1,-1;1987-06-01_ "1987-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-06-01_,-1,-1;1987-07-01_ "1987-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-07-01_,-1,-1;1987-08-01_ "1987-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-08-01_,-1,-1;1987-09-01_ "1987-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-09-01_,-1,-1;1987-10-01_ "1987-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-10-01_,-1,-1;1987-11-01_ "1987-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-11-01_,-1,-1;1987-12-01_ "1987-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1987-12-01_,-1,-1;1988-01-01_ "1988-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-01-01_,-1,-1;1988-02-01_ "1988-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-02-01_,-1,-1;1988-03-01_ "1988-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-03-01_,-1,-1;1988-04-01_ "1988-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-04-01_,-1,-1;1988-05-01_ "1988-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-05-01_,-1,-1;1988-06-01_ "1988-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-06-01_,-1,-1;1988-07-01_ "1988-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-07-01_,-1,-1;1988-08-01_ "1988-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-08-01_,-1,-1;1988-09-01_ "1988-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-09-01_,-1,-1;1988-10-01_ "1988-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-10-01_,-1,-1;1988-11-01_ "1988-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-11-01_,-1,-1;1988-12-01_ "1988-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1988-12-01_,-1,-1;1989-01-01_ "1989-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-01-01_,-1,-1;1989-02-01_ "1989-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-02-01_,-1,-1;1989-03-01_ "1989-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-03-01_,-1,-1;1989-04-01_ "1989-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-04-01_,-1,-1;1989-05-01_ "1989-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-05-01_,-1,-1;1989-06-01_ "1989-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-06-01_,-1,-1;1989-07-01_ "1989-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-07-01_,-1,-1;1989-08-01_ "1989-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-08-01_,-1,-1;1989-09-01_ "1989-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-09-01_,-1,-1;1989-10-01_ "1989-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-10-01_,-1,-1;1989-11-01_ "1989-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-11-01_,-1,-1;1989-12-01_ "1989-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1989-12-01_,-1,-1;1990-01-01_ "1990-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-01-01_,-1,-1;1990-02-01_ "1990-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-02-01_,-1,-1;1990-03-01_ "1990-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-03-01_,-1,-1;1990-04-01_ "1990-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-04-01_,-1,-1;1990-05-01_ "1990-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-05-01_,-1,-1;1990-06-01_ "1990-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-06-01_,-1,-1;1990-07-01_ "1990-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-07-01_,-1,-1;1990-08-01_ "1990-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-08-01_,-1,-1;1990-09-01_ "1990-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-09-01_,-1,-1;1990-10-01_ "1990-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-10-01_,-1,-1;1990-11-01_ "1990-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-11-01_,-1,-1;1990-12-01_ "1990-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1990-12-01_,-1,-1;1991-01-01_ "1991-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-01-01_,-1,-1;1991-02-01_ "1991-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-02-01_,-1,-1;1991-03-01_ "1991-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-03-01_,-1,-1;1991-04-01_ "1991-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-04-01_,-1,-1;1991-05-01_ "1991-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-05-01_,-1,-1;1991-06-01_ "1991-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-06-01_,-1,-1;1991-07-01_ "1991-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-07-01_,-1,-1;1991-08-01_ "1991-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-08-01_,-1,-1;1991-09-01_ "1991-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-09-01_,-1,-1;1991-10-01_ "1991-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-10-01_,-1,-1;1991-11-01_ "1991-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-11-01_,-1,-1;1991-12-01_ "1991-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1991-12-01_,-1,-1;1992-01-01_ "1992-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-01-01_,-1,-1;1992-02-01_ "1992-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-02-01_,-1,-1;1992-03-01_ "1992-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-03-01_,-1,-1;1992-04-01_ "1992-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-04-01_,-1,-1;1992-05-01_ "1992-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-05-01_,-1,-1;1992-06-01_ "1992-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-06-01_,-1,-1;1992-07-01_ "1992-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-07-01_,-1,-1;1992-08-01_ "1992-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-08-01_,-1,-1;1992-09-01_ "1992-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-09-01_,-1,-1;1992-10-01_ "1992-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-10-01_,-1,-1;1992-11-01_ "1992-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-11-01_,-1,-1;1992-12-01_ "1992-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1992-12-01_,-1,-1;1993-01-01_ "1993-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-01-01_,-1,-1;1993-02-01_ "1993-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-02-01_,-1,-1;1993-03-01_ "1993-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-03-01_,-1,-1;1993-04-01_ "1993-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-04-01_,-1,-1;1993-05-01_ "1993-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-05-01_,-1,-1;1993-06-01_ "1993-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-06-01_,-1,-1;1993-07-01_ "1993-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-07-01_,-1,-1;1993-08-01_ "1993-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-08-01_,-1,-1;1993-09-01_ "1993-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-09-01_,-1,-1;1993-10-01_ "1993-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-10-01_,-1,-1;1993-11-01_ "1993-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-11-01_,-1,-1;1993-12-01_ "1993-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1993-12-01_,-1,-1;1994-01-01_ "1994-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-01-01_,-1,-1;1994-02-01_ "1994-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-02-01_,-1,-1;1994-03-01_ "1994-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-03-01_,-1,-1;1994-04-01_ "1994-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-04-01_,-1,-1;1994-05-01_ "1994-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-05-01_,-1,-1;1994-06-01_ "1994-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-06-01_,-1,-1;1994-07-01_ "1994-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-07-01_,-1,-1;1994-08-01_ "1994-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-08-01_,-1,-1;1994-09-01_ "1994-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-09-01_,-1,-1;1994-10-01_ "1994-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-10-01_,-1,-1;1994-11-01_ "1994-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-11-01_,-1,-1;1994-12-01_ "1994-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1994-12-01_,-1,-1;1995-01-01_ "1995-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-01-01_,-1,-1;1995-02-01_ "1995-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-02-01_,-1,-1;1995-03-01_ "1995-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-03-01_,-1,-1;1995-04-01_ "1995-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-04-01_,-1,-1;1995-05-01_ "1995-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-05-01_,-1,-1;1995-06-01_ "1995-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-06-01_,-1,-1;1995-07-01_ "1995-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-07-01_,-1,-1;1995-08-01_ "1995-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-08-01_,-1,-1;1995-09-01_ "1995-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-09-01_,-1,-1;1995-10-01_ "1995-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-10-01_,-1,-1;1995-11-01_ "1995-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-11-01_,-1,-1;1995-12-01_ "1995-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1995-12-01_,-1,-1;1996-01-01_ "1996-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-01-01_,-1,-1;1996-02-01_ "1996-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-02-01_,-1,-1;1996-03-01_ "1996-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-03-01_,-1,-1;1996-04-01_ "1996-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-04-01_,-1,-1;1996-05-01_ "1996-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-05-01_,-1,-1;1996-06-01_ "1996-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-06-01_,-1,-1;1996-07-01_ "1996-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-07-01_,-1,-1;1996-08-01_ "1996-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-08-01_,-1,-1;1996-09-01_ "1996-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-09-01_,-1,-1;1996-10-01_ "1996-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-10-01_,-1,-1;1996-11-01_ "1996-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-11-01_,-1,-1;1996-12-01_ "1996-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1996-12-01_,-1,-1;1997-01-01_ "1997-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-01-01_,-1,-1;1997-02-01_ "1997-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-02-01_,-1,-1;1997-03-01_ "1997-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-03-01_,-1,-1;1997-04-01_ "1997-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-04-01_,-1,-1;1997-05-01_ "1997-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-05-01_,-1,-1;1997-06-01_ "1997-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-06-01_,-1,-1;1997-07-01_ "1997-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-07-01_,-1,-1;1997-08-01_ "1997-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-08-01_,-1,-1;1997-09-01_ "1997-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-09-01_,-1,-1;1997-10-01_ "1997-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-10-01_,-1,-1;1997-11-01_ "1997-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-11-01_,-1,-1;1997-12-01_ "1997-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1997-12-01_,-1,-1;1998-01-01_ "1998-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-01-01_,-1,-1;1998-02-01_ "1998-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-02-01_,-1,-1;1998-03-01_ "1998-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-03-01_,-1,-1;1998-04-01_ "1998-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-04-01_,-1,-1;1998-05-01_ "1998-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-05-01_,-1,-1;1998-06-01_ "1998-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-06-01_,-1,-1;1998-07-01_ "1998-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-07-01_,-1,-1;1998-08-01_ "1998-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-08-01_,-1,-1;1998-09-01_ "1998-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-09-01_,-1,-1;1998-10-01_ "1998-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-10-01_,-1,-1;1998-11-01_ "1998-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-11-01_,-1,-1;1998-12-01_ "1998-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1998-12-01_,-1,-1;1999-01-01_ "1999-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-01-01_,-1,-1;1999-02-01_ "1999-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-02-01_,-1,-1;1999-03-01_ "1999-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-03-01_,-1,-1;1999-04-01_ "1999-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-04-01_,-1,-1;1999-05-01_ "1999-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-05-01_,-1,-1;1999-06-01_ "1999-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-06-01_,-1,-1;1999-07-01_ "1999-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-07-01_,-1,-1;1999-08-01_ "1999-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-08-01_,-1,-1;1999-09-01_ "1999-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-09-01_,-1,-1;1999-10-01_ "1999-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-10-01_,-1,-1;1999-11-01_ "1999-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-11-01_,-1,-1;1999-12-01_ "1999-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,1999-12-01_,-1,-1;2000-01-01_ "2000-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-01-01_,-1,-1;2000-02-01_ "2000-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-02-01_,-1,-1;2000-03-01_ "2000-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-03-01_,-1,-1;2000-04-01_ "2000-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-04-01_,-1,-1;2000-05-01_ "2000-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-05-01_,-1,-1;2000-06-01_ "2000-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-06-01_,-1,-1;2000-07-01_ "2000-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-07-01_,-1,-1;2000-08-01_ "2000-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-08-01_,-1,-1;2000-09-01_ "2000-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-09-01_,-1,-1;2000-10-01_ "2000-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-10-01_,-1,-1;2000-11-01_ "2000-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-11-01_,-1,-1;2000-12-01_ "2000-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2000-12-01_,-1,-1;2001-01-01_ "2001-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-01-01_,-1,-1;2001-02-01_ "2001-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-02-01_,-1,-1;2001-03-01_ "2001-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-03-01_,-1,-1;2001-04-01_ "2001-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-04-01_,-1,-1;2001-05-01_ "2001-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-05-01_,-1,-1;2001-06-01_ "2001-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-06-01_,-1,-1;2001-07-01_ "2001-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-07-01_,-1,-1;2001-08-01_ "2001-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-08-01_,-1,-1;2001-09-01_ "2001-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-09-01_,-1,-1;2001-10-01_ "2001-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-10-01_,-1,-1;2001-11-01_ "2001-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-11-01_,-1,-1;2001-12-01_ "2001-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2001-12-01_,-1,-1;2002-01-01_ "2002-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-01-01_,-1,-1;2002-02-01_ "2002-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-02-01_,-1,-1;2002-03-01_ "2002-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-03-01_,-1,-1;2002-04-01_ "2002-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-04-01_,-1,-1;2002-05-01_ "2002-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-05-01_,-1,-1;2002-06-01_ "2002-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-06-01_,-1,-1;2002-07-01_ "2002-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-07-01_,-1,-1;2002-08-01_ "2002-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-08-01_,-1,-1;2002-09-01_ "2002-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-09-01_,-1,-1;2002-10-01_ "2002-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-10-01_,-1,-1;2002-11-01_ "2002-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-11-01_,-1,-1;2002-12-01_ "2002-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2002-12-01_,-1,-1;2003-01-01_ "2003-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-01-01_,-1,-1;2003-02-01_ "2003-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-02-01_,-1,-1;2003-03-01_ "2003-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-03-01_,-1,-1;2003-04-01_ "2003-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-04-01_,-1,-1;2003-05-01_ "2003-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-05-01_,-1,-1;2003-06-01_ "2003-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-06-01_,-1,-1;2003-07-01_ "2003-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-07-01_,-1,-1;2003-08-01_ "2003-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-08-01_,-1,-1;2003-09-01_ "2003-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-09-01_,-1,-1;2003-10-01_ "2003-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-10-01_,-1,-1;2003-11-01_ "2003-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-11-01_,-1,-1;2003-12-01_ "2003-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2003-12-01_,-1,-1;2004-01-01_ "2004-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-01-01_,-1,-1;2004-02-01_ "2004-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-02-01_,-1,-1;2004-03-01_ "2004-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-03-01_,-1,-1;2004-04-01_ "2004-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-04-01_,-1,-1;2004-05-01_ "2004-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-05-01_,-1,-1;2004-06-01_ "2004-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-06-01_,-1,-1;2004-07-01_ "2004-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-07-01_,-1,-1;2004-08-01_ "2004-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-08-01_,-1,-1;2004-09-01_ "2004-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-09-01_,-1,-1;2004-10-01_ "2004-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-10-01_,-1,-1;2004-11-01_ "2004-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-11-01_,-1,-1;2004-12-01_ "2004-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2004-12-01_,-1,-1;2005-01-01_ "2005-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-01-01_,-1,-1;2005-02-01_ "2005-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-02-01_,-1,-1;2005-03-01_ "2005-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-03-01_,-1,-1;2005-04-01_ "2005-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-04-01_,-1,-1;2005-05-01_ "2005-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-05-01_,-1,-1;2005-06-01_ "2005-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-06-01_,-1,-1;2005-07-01_ "2005-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-07-01_,-1,-1;2005-08-01_ "2005-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-08-01_,-1,-1;2005-09-01_ "2005-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-09-01_,-1,-1;2005-10-01_ "2005-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-10-01_,-1,-1;2005-11-01_ "2005-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-11-01_,-1,-1;2005-12-01_ "2005-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2005-12-01_,-1,-1;2006-01-01_ "2006-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-01-01_,-1,-1;2006-02-01_ "2006-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-02-01_,-1,-1;2006-03-01_ "2006-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-03-01_,-1,-1;2006-04-01_ "2006-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-04-01_,-1,-1;2006-05-01_ "2006-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-05-01_,-1,-1;2006-06-01_ "2006-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-06-01_,-1,-1;2006-07-01_ "2006-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-07-01_,-1,-1;2006-08-01_ "2006-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-08-01_,-1,-1;2006-09-01_ "2006-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-09-01_,-1,-1;2006-10-01_ "2006-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-10-01_,-1,-1;2006-11-01_ "2006-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-11-01_,-1,-1;2006-12-01_ "2006-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2006-12-01_,-1,-1;2007-01-01_ "2007-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-01-01_,-1,-1;2007-02-01_ "2007-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-02-01_,-1,-1;2007-03-01_ "2007-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-03-01_,-1,-1;2007-04-01_ "2007-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-04-01_,-1,-1;2007-05-01_ "2007-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-05-01_,-1,-1;2007-06-01_ "2007-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-06-01_,-1,-1;2007-07-01_ "2007-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-07-01_,-1,-1;2007-08-01_ "2007-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-08-01_,-1,-1;2007-09-01_ "2007-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-09-01_,-1,-1;2007-10-01_ "2007-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-10-01_,-1,-1;2007-11-01_ "2007-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-11-01_,-1,-1;2007-12-01_ "2007-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2007-12-01_,-1,-1;2008-01-01_ "2008-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-01-01_,-1,-1;2008-02-01_ "2008-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-02-01_,-1,-1;2008-03-01_ "2008-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-03-01_,-1,-1;2008-04-01_ "2008-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-04-01_,-1,-1;2008-05-01_ "2008-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-05-01_,-1,-1;2008-06-01_ "2008-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-06-01_,-1,-1;2008-07-01_ "2008-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-07-01_,-1,-1;2008-08-01_ "2008-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-08-01_,-1,-1;2008-09-01_ "2008-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-09-01_,-1,-1;2008-10-01_ "2008-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-10-01_,-1,-1;2008-11-01_ "2008-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-11-01_,-1,-1;2008-12-01_ "2008-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2008-12-01_,-1,-1;2009-01-01_ "2009-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-01-01_,-1,-1;2009-02-01_ "2009-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-02-01_,-1,-1;2009-03-01_ "2009-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-03-01_,-1,-1;2009-04-01_ "2009-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-04-01_,-1,-1;2009-05-01_ "2009-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-05-01_,-1,-1;2009-06-01_ "2009-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-06-01_,-1,-1;2009-07-01_ "2009-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-07-01_,-1,-1;2009-08-01_ "2009-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-08-01_,-1,-1;2009-09-01_ "2009-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-09-01_,-1,-1;2009-10-01_ "2009-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-10-01_,-1,-1;2009-11-01_ "2009-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-11-01_,-1,-1;2009-12-01_ "2009-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2009-12-01_,-1,-1;2010-01-01_ "2010-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-01-01_,-1,-1;2010-02-01_ "2010-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-02-01_,-1,-1;2010-03-01_ "2010-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-03-01_,-1,-1;2010-04-01_ "2010-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-04-01_,-1,-1;2010-05-01_ "2010-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-05-01_,-1,-1;2010-06-01_ "2010-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-06-01_,-1,-1;2010-07-01_ "2010-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-07-01_,-1,-1;2010-08-01_ "2010-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-08-01_,-1,-1;2010-09-01_ "2010-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-09-01_,-1,-1;2010-10-01_ "2010-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-10-01_,-1,-1;2010-11-01_ "2010-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-11-01_,-1,-1;2010-12-01_ "2010-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2010-12-01_,-1,-1;2011-01-01_ "2011-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-01-01_,-1,-1;2011-02-01_ "2011-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-02-01_,-1,-1;2011-03-01_ "2011-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-03-01_,-1,-1;2011-04-01_ "2011-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-04-01_,-1,-1;2011-05-01_ "2011-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-05-01_,-1,-1;2011-06-01_ "2011-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-06-01_,-1,-1;2011-07-01_ "2011-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-07-01_,-1,-1;2011-08-01_ "2011-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-08-01_,-1,-1;2011-09-01_ "2011-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-09-01_,-1,-1;2011-10-01_ "2011-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-10-01_,-1,-1;2011-11-01_ "2011-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-11-01_,-1,-1;2011-12-01_ "2011-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2011-12-01_,-1,-1;2012-01-01_ "2012-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-01-01_,-1,-1;2012-02-01_ "2012-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-02-01_,-1,-1;2012-03-01_ "2012-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-03-01_,-1,-1;2012-04-01_ "2012-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-04-01_,-1,-1;2012-05-01_ "2012-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-05-01_,-1,-1;2012-06-01_ "2012-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-06-01_,-1,-1;2012-07-01_ "2012-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-07-01_,-1,-1;2012-08-01_ "2012-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-08-01_,-1,-1;2012-09-01_ "2012-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-09-01_,-1,-1;2012-10-01_ "2012-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-10-01_,-1,-1;2012-11-01_ "2012-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-11-01_,-1,-1;2012-12-01_ "2012-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2012-12-01_,-1,-1;2013-01-01_ "2013-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-01-01_,-1,-1;2013-02-01_ "2013-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-02-01_,-1,-1;2013-03-01_ "2013-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-03-01_,-1,-1;2013-04-01_ "2013-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-04-01_,-1,-1;2013-05-01_ "2013-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-05-01_,-1,-1;2013-06-01_ "2013-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-06-01_,-1,-1;2013-07-01_ "2013-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-07-01_,-1,-1;2013-08-01_ "2013-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-08-01_,-1,-1;2013-09-01_ "2013-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-09-01_,-1,-1;2013-10-01_ "2013-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-10-01_,-1,-1;2013-11-01_ "2013-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-11-01_,-1,-1;2013-12-01_ "2013-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2013-12-01_,-1,-1;2014-01-01_ "2014-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-01-01_,-1,-1;2014-02-01_ "2014-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-02-01_,-1,-1;2014-03-01_ "2014-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-03-01_,-1,-1;2014-04-01_ "2014-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-04-01_,-1,-1;2014-05-01_ "2014-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-05-01_,-1,-1;2014-06-01_ "2014-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-06-01_,-1,-1;2014-07-01_ "2014-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-07-01_,-1,-1;2014-08-01_ "2014-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-08-01_,-1,-1;2014-09-01_ "2014-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-09-01_,-1,-1;2014-10-01_ "2014-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-10-01_,-1,-1;2014-11-01_ "2014-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-11-01_,-1,-1;2014-12-01_ "2014-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2014-12-01_,-1,-1;2015-01-01_ "2015-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-01-01_,-1,-1;2015-02-01_ "2015-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-02-01_,-1,-1;2015-03-01_ "2015-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-03-01_,-1,-1;2015-04-01_ "2015-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-04-01_,-1,-1;2015-05-01_ "2015-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-05-01_,-1,-1;2015-06-01_ "2015-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-06-01_,-1,-1;2015-07-01_ "2015-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-07-01_,-1,-1;2015-08-01_ "2015-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-08-01_,-1,-1;2015-09-01_ "2015-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-09-01_,-1,-1;2015-10-01_ "2015-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-10-01_,-1,-1;2015-11-01_ "2015-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-11-01_,-1,-1;2015-12-01_ "2015-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2015-12-01_,-1,-1;2016-01-01_ "2016-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-01-01_,-1,-1;2016-02-01_ "2016-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-02-01_,-1,-1;2016-03-01_ "2016-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-03-01_,-1,-1;2016-04-01_ "2016-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-04-01_,-1,-1;2016-05-01_ "2016-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-05-01_,-1,-1;2016-06-01_ "2016-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-06-01_,-1,-1;2016-07-01_ "2016-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-07-01_,-1,-1;2016-08-01_ "2016-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-08-01_,-1,-1;2016-09-01_ "2016-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-09-01_,-1,-1;2016-10-01_ "2016-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-10-01_,-1,-1;2016-11-01_ "2016-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-11-01_,-1,-1;2016-12-01_ "2016-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2016-12-01_,-1,-1;2017-01-01_ "2017-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-01-01_,-1,-1;2017-02-01_ "2017-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-02-01_,-1,-1;2017-03-01_ "2017-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-03-01_,-1,-1;2017-04-01_ "2017-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-04-01_,-1,-1;2017-05-01_ "2017-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-05-01_,-1,-1;2017-06-01_ "2017-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-06-01_,-1,-1;2017-07-01_ "2017-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-07-01_,-1,-1;2017-08-01_ "2017-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-08-01_,-1,-1;2017-09-01_ "2017-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-09-01_,-1,-1;2017-10-01_ "2017-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-10-01_,-1,-1;2017-11-01_ "2017-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-11-01_,-1,-1;2017-12-01_ "2017-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2017-12-01_,-1,-1;2018-01-01_ "2018-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-01-01_,-1,-1;2018-02-01_ "2018-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-02-01_,-1,-1;2018-03-01_ "2018-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-03-01_,-1,-1;2018-04-01_ "2018-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-04-01_,-1,-1;2018-05-01_ "2018-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-05-01_,-1,-1;2018-06-01_ "2018-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-06-01_,-1,-1;2018-07-01_ "2018-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-07-01_,-1,-1;2018-08-01_ "2018-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-08-01_,-1,-1;2018-09-01_ "2018-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-09-01_,-1,-1;2018-10-01_ "2018-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-10-01_,-1,-1;2018-11-01_ "2018-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-11-01_,-1,-1;2018-12-01_ "2018-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2018-12-01_,-1,-1;2019-01-01_ "2019-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-01-01_,-1,-1;2019-02-01_ "2019-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-02-01_,-1,-1;2019-03-01_ "2019-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-03-01_,-1,-1;2019-04-01_ "2019-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-04-01_,-1,-1;2019-05-01_ "2019-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-05-01_,-1,-1;2019-06-01_ "2019-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-06-01_,-1,-1;2019-07-01_ "2019-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-07-01_,-1,-1;2019-08-01_ "2019-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-08-01_,-1,-1;2019-09-01_ "2019-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-09-01_,-1,-1;2019-10-01_ "2019-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-10-01_,-1,-1;2019-11-01_ "2019-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-11-01_,-1,-1;2019-12-01_ "2019-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2019-12-01_,-1,-1;2020-01-01_ "2020-01-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-01-01_,-1,-1;2020-02-01_ "2020-02-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-02-01_,-1,-1;2020-03-01_ "2020-03-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-03-01_,-1,-1;2020-04-01_ "2020-04-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-04-01_,-1,-1;2020-05-01_ "2020-05-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-05-01_,-1,-1;2020-06-01_ "2020-06-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-06-01_,-1,-1;2020-07-01_ "2020-07-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-07-01_,-1,-1;2020-08-01_ "2020-08-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-08-01_,-1,-1;2020-09-01_ "2020-09-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-09-01_,-1,-1;2020-10-01_ "2020-10-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-10-01_,-1,-1;2020-11-01_ "2020-11-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-11-01_,-1,-1;2020-12-01_ "2020-12-01_" true true false 8 Double 0 0,First,#,WEAP_Escorrentia_convertido.csv,2020-12-01_,-1,-1',
    sort_field=None
)
C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\pandas\core\dtypes\cast.py:1056: RuntimeWarning: invalid value encountered in cast
  if (arr.astype(int) == arr).all():
C:\Program Files\ArcGIS\Pro\bin\Python\envs\arcgispro-py3\Lib\site-packages\pandas\core\dtypes\cast.py:1080: RuntimeWarning: invalid value encountered in cast
  if (arr.astype(int) == arr).all():
Out[8]:
'C:\\Users\\USUARIO\\Downloads\\SEI\\Time_series\\WEAP_Escorrentia_completo.csv'

Joining .shp and .csv files¶

In [9]:
arcpy.management.JoinField(
    in_data=r"C:\Users\USUARIO\Downloads\SEI\Weap_data\WEAP_Catchment.shp",
    in_field="Name",
    join_table="WEAP_Escorrentia_completo.csv",
    join_field="Branch",
    fields=None,
    fm_option="NOT_USE_FM",
    field_mapping=None,
    index_join_fields="NO_INDEXES"
)
Out[9]:

Messages

Start Time: Monday, August 18, 2025 9:28:05 PM
Succeeded at Monday, August 18, 2025 9:28:24 PM (Elapsed Time: 19.03 seconds)

Before importing the .shp file, a column is added to calculate the total area in km2 for the 260 basins.¶

Verification of the Union or “Join” operation¶

In [10]:
weap = r"C:\Users\USUARIO\Downloads\SEI\Weap_data\WEAP_Catchment.shp"
weap_catchment = pd.DataFrame.spatial.from_featureclass(os.path.join(path, weap), sr=SpatialReference(4326).as_arcpy)
In [11]:
weap_catchment.head(-10)
Out[11]:
FID ObjID Name Branch F1980_01_0 F1980_02_0 F1980_03_0 F1980_04_0 F1980_05_0 F1980_06_0 ... F2020_06_0 F2020_07_0 F2020_08_0 F2020_09_0 F2020_10_0 F2020_11_0 F2020_12_0 avg_80_20 area_total SHAPE
0 0 53 UH_2_6 UH_2_6 330752700.0 699957284.0 644017571.0 154571207.0 17831977.0 600325.0 ... 3006.6 235.636 14.1813 0.473526 2960.03 1542.28 97618053.0 207440034.738 4606.790039 {"rings": [[[-67.7075, -10.704166666666667], [...
1 1 57 UH_2_5 UH_2_5 968854832.0 1483257275.0 1427413960.0 310006100.0 29662068.0 452660.0 ... 2001.65 83.9881 4.08898 41.8676 1303.93 238.453 115428993.0 422400967.332 8425.179688 {"rings": [[[-66.38333333333334, -9.8666666666...
2 2 61 UH_2_4 UH_2_4 781887888.0 1529929220.0 1555420813.0 297579729.0 19588808.0 170753.0 ... 502.891 0.01488 0.000015 0.000116 9.3606 1.58326 42571252.0 433356869.52 8388.660156 {"rings": [[[-65.65, -9.814166666666667], [-65...
3 3 45 UH_2_2 UH_2_2 114483057.0 320855975.0 270068309.0 16426213.0 212852.0 2072.8 ... 0.0001 0.0 0.0 0.0 0.000617 0.000124 149.928 3318965.10962 10564.5 {"rings": [[[-65.44583333333334, -9.6491666666...
4 4 81 UH_2_11 UH_2_11 172464988.0 1002103541.0 661868356.0 81592312.0 4327008.0 262537.0 ... 6.26367 114.468 5.08491 0.213873 1260.11 144.996 2849411.0 183321172.168 12543.900391 {"rings": [[[-67.32416666666667, -11.510833333...
... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ... ...
245 245 513 UH_2_47 UH_2_47 1451437493.0 1683504891.0 1206929717.0 903983667.0 419495505.0 22592901.0 ... 340075409.0 11245889.0 35207.6 1570.51 10.5707 690.594 1111958463.0 597696626.602 6963.399902 {"rings": [[[-65.04833333333333, -14.763333333...
246 246 3012 UH_2_60_2 UH_2_60_2 1304923709.0 2126897158.0 846956330.0 1143513124.0 385750416.0 17517666.0 ... 8894617.0 1588.46 0.090873 0.001497 0.001633 3.78587 130461350.0 485700266.475 11384.799805 {"rings": [[[-64.97416666666666, -14.891666666...
247 247 3016 UH_2_46_2 UH_2_46_2 1830233657.0 1318950794.0 970824526.0 434566239.0 117109792.0 12556864.0 ... 155092634.0 3573556.0 354046.0 24082.7 0.176418 7.5472 793848624.0 426742084.93 6296.720215 {"rings": [[[-65.85, -14.968333333333334], [-6...
248 248 3020 UH_2_Q_Porto Velho UH_2_Q_Porto Velho 724627798.0 3629395980.0 3290146085.0 601668140.0 27007421.0 256653.0 ... 186075.0 146346.0 62314.6 96851.0 189473.0 290376.0 30698898.0 870168965.125 23237.099609 {"rings": [[[-63.91916666666667, -8.7583333333...
249 249 3029 UH_2_33_2 UH_2_33_2 97998476.0 351283392.0 265564315.0 25120393.0 910353.0 19920.2 ... 0.039593 0.000228 0.000011 0.000025 0.024244 0.020005 13143.2 15884306.0116 23869.599609 {"rings": [[[-65.33583333333333, -10.808333333...

250 rows × 499 columns

Publishing and uploading the file to the ArcGIS Online portal¶

Inconsistencies with automatic publication in ArcGIS Online:

Due to some errors related to the sharing_draft commands, we have opted to manually publish the shapefile containing information on the 260 watersheds and time series

Below is a screenshot of the information provided.

image.png

Script for publishing to ArcGIS Online¶

In [12]:
aprx = arcpy.mp.ArcGISProject("C:/Users/USUARIO/Downloads/SEI/Research_Associate_Water/Research_Associate_Water.aprx")
m = aprx.listMaps("MapWeap")[0] # Replace "Map Name" with your map's name
# Example for a FeatureSharingDraft from a map

server_type = "HOSTING_SERVER"
service_name = "Weap_Data_SEI"

sharing_draft = m.getWebLayerSharingDraft(server_type, "FEATURE", service_name) 
sharing_draft.summary = "Time Series and Data from 260 River Basins in South America, include the runoff as a unique variable "
sharing_draft.tags = "GIS, Water_Resources, SEI"
#sharing_draft.access_type = "organization"

service_definition_draft = r"C:Temp/MyServiceDefinitionDraft.sddraft"
service_definition = r"C:/Temp/MyServiceDefinition.sd"

sharing_draft.exportToSDDraft(service_definition_draft)
arcpy.StageService_server(service_definition_draft, service_definition)

arcpy.UploadServiceDefinition_server(service_definition, gis.url)
---------------------------------------------------------------------------
ValueError                                Traceback (most recent call last)
Cell In[12], line 16
     13 service_definition_draft = r"C:Temp/MyServiceDefinitionDraft.sddraft"
     14 service_definition = r"C:/Temp/MyServiceDefinition.sd"
---> 16 sharing_draft.exportToSDDraft(service_definition_draft)
     17 arcpy.StageService_server(service_definition_draft, service_definition)
     19 arcpy.UploadServiceDefinition_server(service_definition, gis.url)

File C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\sharing.py:47, in _SharingDraftBase.exportToSDDraft(self, out_sddraft)
     45 def exportToSDDraft(self, out_sddraft):
     46     self._validateParameters()
---> 47     return _convertArcObjectToPythonObject(self._arc_object.exportToSDDraft(out_sddraft, self))

ValueError: Staging path is invalid or inaccessible: C:\Users\USUARIO\Downloads\SEI\Research_Associate_Water\Temp\

Displaying the base map and cartography¶

Creation of the base map¶

In [25]:
Bolivia_map1 = gis.map("Bolivia")
Bolivia_map1.zoom = 5
Bolivia_map1.basemap.basemap = 'hybrid'
Bolivia_map1
Out[25]:
Map(center=[-1882544.102516555, -7190960.141718488], extent={'xmin': -7898952.103163708, 'ymin': -2635750.5346…

image.png

Adding data hosted on ArcGIS Online¶

In [21]:
search_title = "Weap_Data_SEI"
search_owner = "camendezv_UDFJC"
query_string = f"title:\"{search_title}\" AND owner:\"{search_owner}\""
In [26]:
Bol_data = gis.content.search(query=query_string, item_type="Feature Layer")
Bol_data[0]
Out[26]:
No description has been provided for this image
Weap_Data_SEI
Time Series and Data from 260 River Basins in South America, include the runoff as a unique variable
No description has been provided for this imageFeature Layer Collection by camendezv_UDFJC
Last Modified: August 18, 2025
0 comments, 53 views

In [27]:
Bol_data_item = gis.content.get('a7b5b4dac30d4497ba90de267989e004')
Bol_data_layer = Bol_data_item.layers[0]
Bol_data_layer
Out[27]:
<FeatureLayer url:"https://services.arcgis.com/deQSb0Gn7gDPf3uV/arcgis/rest/services/Weap_Data_SEI/FeatureServer/1">
In [28]:
Bolivia_map1.content.add(Bol_data_layer)
In [11]:
Bolivia_map2 = gis.map("Bolivia")
Bolivia_map2.zoom = 5
Bolivia_map2.basemap.basemap = 'hybrid'
Bolivia_map2
Out[11]:
Map(center=[-1882544.102516555, -7190960.141718488], extent={'xmin': -7898952.103163708, 'ymin': -2635750.5346…

image.png

Creation and updating of symbols¶

In [12]:
renderer_manager = Bolivia_map1.content.renderer(0)
smart_mapping_manager = renderer_manager.smart_mapping()
smart_mapping_manager.class_breaks_renderer(break_type="color", field="avg_80_20")
In [13]:
from arcgis.map.renderers import (ClassBreaksRenderer,ClassBreakInfo,SizeInfoVisualVariable)
from arcgis.map.symbols import SimpleLineSymbolEsriSLS, SimpleFillSymbolEsriSFS

Establishment of the 5 classes by color and rank¶

In [14]:
# Define the class breaks with proper data classes
class_break_infos = [
    ClassBreakInfo(
        class_max_value=31628583.28,
        label="< 10%",
        symbol=SimpleFillSymbolEsriSFS(
            **{
                "type": "esriSFS",
                "style": "esriSFSSolid",
                "color": [237, 248, 251, 204],  # Light greenish color
                "outline": {"color": [153, 153, 153, 255], "width": 0.375},
            }
        ),
    ),
    ClassBreakInfo(
        class_max_value=135374970.74,
        label="10% - 39.5%",
        symbol=SimpleFillSymbolEsriSFS(
            **{
                "type": "esriSFS",
                "style": "esriSFSSolid",
                "color": [178, 226, 226, 204],  # Slightly darker green
                "outline": {"color": [153, 153, 153, 255], "width": 0.375},
            }
        ),
    ),
    ClassBreakInfo(
        class_max_value=368868773.39,
        label="39.5% - 54%",
        symbol=SimpleFillSymbolEsriSFS(
            **{
                "type": "esriSFS",
                "style": "esriSFSSolid",
                "color": [102, 194, 164, 204],  # Medium green
                "outline": {"color": [153, 153, 153, 255], "width": 0.375},
            }
        ),
    ),
    ClassBreakInfo(
        class_max_value=870168965.12,
        label="54% - 68%",
        symbol=SimpleFillSymbolEsriSFS(
            **{
                "type": "esriSFS",
                "style": "esriSFSSolid",
                "color": [44, 162, 95, 204],  # Dark green
                "outline": {"color": [153, 153, 153, 255], "width": 0.375},
            }
        ),
    ),
    ClassBreakInfo(
        class_max_value=2162925096.79,
        label="> 68%",
        symbol=SimpleFillSymbolEsriSFS(
            **{
                "type": "esriSFS",
                "style": "esriSFSSolid",
                "color": [0, 109, 44, 204],  # Darkest green
                "outline": {"color": [153, 153, 153, 255], "width": 0.375},
            }
        ),
    ),
]

# Create the ClassBreaksRenderer using the new dataclass structure
class_breaks_renderer = ClassBreaksRenderer(
    field="avg_80_20",
    class_break_infos=class_break_infos,
    normalization_type=None,  # Change to 'esriNormalizeByField' if you want normalization
)
In [15]:
# Add the layer to the map and visualize
Bolivia_map2.content.add(Bol_data_layer, drawing_info={"renderer": class_breaks_renderer.dict()})
Bolivia_map2
Out[15]:
Map(center=[-64.59749402799997, -16.777136868398472], extent={'spatialReference': {'latestWkid': 3857, 'wkid':…
In [ ]:
 
In [ ]:
 
In [ ]: